package com.tl.bootmeter.mapper;

import com.tl.bootmeter.pojo.MeterMode;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MeterModeMapper {

    //根据仪表编号查询最近日期的24条数据
    @Select("select * from (select * from METER_MODE where meter_sn = 'TL0111909302' order by meter_timeStamp DESC) modelist LIMIT 0,24")
    List<MeterMode> selectAllMeterModeBySn(String meter_sn);
}
